home *** CD-ROM | disk | FTP | other *** search
/ Inter.Net 55-1 / Inter.Net 55-1.iso / CBuilder / Setup / BCB / data.z / dbx.dbi < prev    next >
Encoding:
Borland DataBase Explorer Information  |  1998-02-09  |  35.2 KB  |  775 lines
  1.  
  2.  
  3. [Version]
  4. DbXName="Database Explorer"
  5. DbXVersion=3.00
  6.  
  7. [Properties]
  8. DEFAULT DRIVER:Values=Closed,PARADOX,DBASE,FOXPRO,ASCIIDRV
  9. NET PROTOCOL:Values1=Closed,TNS,TCP/IP,SPX/IPX,NETBIOS,NAMED PIPES,DECNET,3270,VINES
  10. NET PROTOCOL:Values2=APPC,ASYNC
  11. OPEN MODE:Values=Closed,READ/WRITE,READ ONLY
  12. SHARE MODE:Values=Closed,EXCLUSIVE,SHARED
  13. STRICTINTEGRTY:Values=Closed,FALSE,TRUE
  14. SQLPASSTHRU MODE:Values=Closed,NOT SHARED,SHARED AUTOCOMMIT,SHARED NOAUTOCOMMIT
  15. LIST SYNONYMS:Values=Closed,NONE,ALL,PRIVATE
  16. BLOB EDIT LOGGING:Values=Closed,FALSE,TRUE
  17. ENABLE SCHEMA CACHE:Values=Closed,FALSE,TRUE
  18. ENABLE BCD:Values=Closed,FALSE,TRUE
  19. ENABLE INTEGERS:Values=Closed,FALSE,TRUE
  20. LOCAL SHARE:Values=Closed,FALSE,TRUE
  21. AUTO ODBC:Values=Closed,FALSE,TRUE
  22. FOURDIGITYEAR:Values=Closed,FALSE,TRUE
  23. YEARBIASED:Values=Closed,FALSE,TRUE
  24. LEADINGZEROM:Values=Closed,FALSE,TRUE
  25. LEADINGZEROD:Values=Closed,FALSE,TRUE
  26. TWELVEHOUR:Values=Closed,FALSE,TRUE
  27. SECONDS:Values=Closed,FALSE,TRUE
  28. MILSECONDS:Values=Closed,FALSE,TRUE
  29. LEADINGZERON:Values=Closed,FALSE,TRUE
  30. COLLCHAR:Values=Closed,0,1,2
  31. DBNLS:Values=Closed,0,1,2
  32. SQLQRYMODE:Values=Closed,LOCAL,SERVER
  33.  
  34. :HelpContext=4039
  35. DB2:HelpContext=4038
  36. INFORMIX:HelpContext=4035
  37. INTRBASE:HelpContext=4037
  38. MSACCESS:HelpContext=4042
  39. MSSQL:HelpContext=4036
  40. ORACLE:HelpContext=4034
  41. STANDARD:HelpContext=4045
  42. SYBASE:HelpContext=4033
  43.  
  44.  
  45.  
  46. [STANDARD Properties]
  47. DriverType:Values=Closed,PARADOX="Paradox",DBASE="dBase",FOXPRO="FoxPro"
  48. BooleanYN:Values=Closed,0="No",-1="Yes",1="Yes"
  49. FieldVChecks:Values=Closed,0="",1="Has Validity Checks",2=""
  50. FieldRights:Values=Closed,0="Read/Write",1="Read Only",2="None",3=""
  51. LookupType:Values1=Closed,0="None",1="Current Field",2="All Corresponding"
  52. LookupType:Values2=3="Current Field & Help",4="All Corresponding & Help"
  53. ReferenceType:Values=Closed,0="Master Of",1="Detail Of"
  54. ReferenceQual:Values=Closed,0="Restrict",1="Cascade"
  55. PrivilegeType:Values1=Closed,0="None",1="Read Only",3="Modify/Read",7="Insert/Modify/Read"
  56. PrivilegeType:Values2=15="Delete/Insert/Modify/Read",31="All Rights",255=
  57. FamilyRightsType:Values=Closed,0="None",1="Form",2="Reports",4="Validity Checks",8="Settings"
  58. FamilyMemberType:Values1=Closed,0="Unknown",1="Table",2="Index",3="Form",4="Report"
  59. FamilyMemberType:Values2=5="Validity Checks",6="Secondary Index",7="Secondary Index"
  60. FamilyMemberType:Values3=8="Blob File"
  61.  
  62. STANDARD:Objects=O:C:0M::"Tables":Table
  63.  
  64. Table:Dataset1=NAME=String:261,FILENAME=String:261,EXTENSION=String:4,TYPE=String:32
  65. Table:Dataset2=DATE=Date,TIME=Time,SIZE=Integer,VIEW=Word,SYNONYM=Word
  66. Table:Dataset3=STRUCTURE=String:32,VERSION=Word,RECORDSIZE=Word,FIELDS=Word
  67. Table:Dataset4=INDEXES=Word,VALCHECKS=Word,REFCHECKS=Word,RECORDS=Integer
  68. Table:Dataset5=PROTECTED=Word,VALID=Word
  69.  
  70. Table:Category=Dataset
  71. Table:Attrs1=TYPE="Type"::NR:::VM=DriverType
  72. Table:Attrs2=DATE="Date"
  73. Table:Attrs3=TIME="Time"
  74. Table:Attrs4=VERSION="Version":2
  75. Table:Attrs5=VALID="Valid":2::::VM=BooleanYN
  76. Table:Attrs6=STRUCTURE="Structure":2
  77. Table:Attrs7=PROTECTED="Protected":2::::VM=BooleanYN
  78. Table:Name=FILENAME,EXTENSION
  79. Table:Objects1=O:P:1M::"Fields":Column
  80. Table:Objects2=O:O:0M::"Indices":Index
  81. Table:Objects3=O:O:0M::"Validity Checks":ValCheck
  82. Table:Objects4=O:O:0M::"Referential Constraints":Reference
  83. Table:Objects5=O:O:0M::"Security Specs":Security
  84. Table:Objects6=O:C:1M::"Family Members":Family
  85.  
  86. Column:Dataset1=FIELDNUM=Word,NAME=String:32,TYPE=Word,SUBTYPE=Word
  87. Column:Dataset2=UNITS1=SmallInt,UNITS2=SmallInt,OFFSET=Word,LENGTH=Word
  88. Column:Dataset3=NULLOFFSET=Word,VCheck=Word,Rights=Word,CALCFIELD=Boolean
  89.  
  90. Column:Category=Column
  91. Column:Order=FIELDNUM
  92. Column:Attrs1=FIELDNUM="Order":2:NR
  93. Column:Attrs2=TYPE="Type":1:NR
  94. Column:Attrs3=UNITS1="Size":1:N
  95. Column:Attrs4=UNITS2="Scale":1:N
  96. Column:Attrs5=LENGTH="Physical Length"
  97. Column:Name=NAME
  98.  
  99. Index:Dataset1=NAME=String:261,INDEXID=Word,TAGNAME=String:32,FORMAT=String:32
  100. Index:Dataset2=PRIMARY=Boolean,UNIQUE=Boolean,DESCENDING=Boolean,AUTO=Boolean
  101. Index:Dataset3=SUBSET=Boolean,KEYISEXP=Boolean,COST=Word,FIELDS=Word,KEYLEN=Word
  102. Index:Dataset4=OUTOFDATE=Boolean,EXPTYPE=Word,FIELDARRAY=Bytes:32
  103. Index:Dataset5=EXPRESSION=String:221,CONDITION=String:221,CASEINSENSITIVE=Boolean
  104. Index:Dataset6=BLOCKSIZE=Word,RESTRNUM=Word,DESCENDINGARRAY=Bytes:32
  105.  
  106. Index:Category=Index
  107. Index:Attrs1=NAME=Name:0,TAGNAME=Tag:0,RESTRNUM="Version":2
  108. Index:Attrs2=PRIMARY="Primary Key":::::VM=BooleanYN
  109. Index:Attrs3=UNIQUE="Unique"::NR:::VM=BooleanYN
  110. Index:Attrs4=AUTO="Maintained":2::::VM=BooleanYN
  111. Index:Attrs5=OUTOFDATE="Out of Date":2::::VM=BooleanYN
  112. Index:Attrs6=FORMAT="Format":2
  113. Index:Attrs7=BLOCKSIZE="Block Size":2
  114. Index:Attrs8=CASEINSENSITIVE="Case Insensitive":2:NR:::VM=BooleanYN
  115. Index:Attrs9=DESCENDING="Descending":2:NR:::VM=BooleanYN
  116. Index:Attrs10=EXPRESSION="Expression":2:N
  117. Index:Attrs11=CONDITION="Subset Condition":2:N
  118. Index:Name=NAME
  119. Index:OnAfterLoad=GetIndexInfo
  120.  
  121. ValCheck:Dataset1=FIELDNUM=Word,REQUIRED=Boolean,HASMINVAL=Boolean
  122. ValCheck:Dataset2=HASMAXVAL=Boolean,HASDEFVAL=Boolean,MINVALUE=String:256
  123. ValCheck:Dataset3=MAXVALUE=String:256,DEFAULT=String:256,PICTURE=String:176
  124. ValCheck:Dataset4=LOOKUPTYPE=Integer,LOOKUPTABLE=String:261
  125.  
  126. ValCheck:Attrs1=FIELDNUM="Field":2:NR
  127. ValCheck:Attrs2=REQUIRED="Required":1:NR:::VM=BooleanYN
  128. ValCheck:Attrs3=MINVALUE="Min Value":1:N
  129. ValCheck:Attrs4=MAXVALUE="Max Value":1:N
  130. ValCheck:Attrs5=DEFAULT="Default Value":1:N
  131. ValCheck:Attrs6=PICTURE="Picture":2:N
  132. ValCheck:Name=FIELDNUM
  133.  
  134. Family:Dataset=NAME=String:32,ID=Word,TYPE=Integer,FILENAME=String:261
  135.  
  136. Family:Attrs1=TYPE="Type":1::::VM=FamilyMemberType
  137. Family:Attrs2=NAME="Object Name":1
  138. Family:Name=FILENAME
  139.  
  140. Reference:Dataset1=REFINTNUM=Word,NAME=String:32,TYPE=Integer
  141. Reference:Dataset2=OTHERTABLE=String:261,MODOP=Integer,DELOP=Integer
  142. Reference:Dataset3=FIELDCOUNT=Word,FIELDARRAY=Bytes:32,OTHERFIELDARRAY=Bytes:32
  143.  
  144. Reference:Attrs1=TYPE="Reference Type":1::::VM=ReferenceType
  145. Reference:Attrs2=OTHERTABLE="Reference To":1:NR
  146. Reference:Attrs3=MODOP="Modify Operation":1:NR:::VM=ReferenceQual
  147. Reference:Attrs4=DELOP="Delete Operation":1:NR:::VM=ReferenceQual
  148. Reference:Name=NAME
  149. Reference:OnAfterLoad=GetReferenceInfo
  150.  
  151. Security:Dataset1=ID=Word,TYPE=Integer,FAMRIGHTS=Word,PASSWORD=String:32
  152. Security:Dataset2=FIELDPRVARRAY=Bytes:1020
  153.  
  154. Security:Attrs1=TYPE="Table Rights":1:NR:::VM=PrivilegeType
  155. Security:Attrs2=FAMRIGHTS="Family Rights":1:NR:::VS=FamilyRightsType:$0F
  156. Security:Name=PASSWORD
  157.  
  158. [MSACCESS Properties]
  159. DriverType:Values=Closed,PARADOX="Paradox",DBASE="dBase",FOXPRO="FoxPro"
  160. BooleanYN:Values=Closed,0="No",-1="Yes",1="Yes"
  161. FieldVChecks:Values=Closed,0="",1="Has Validity Checks",2=""
  162. FieldRights:Values=Closed,0="Read/Write",1="Read Only",2="None",3=""
  163. LookupType:Values1=Closed,0="None",1="Current Field",2="All Corresponding"
  164. LookupType:Values2=3="Current Field & Help",4="All Corresponding & Help"
  165. ReferenceType:Values=Closed,0="Master Of",1="Detail Of"
  166. ReferenceQual:Values=Closed,0="Restrict",1="Cascade"
  167. PrivilegeType:Values1=Closed,0="None",1="Read Only",3="Modify/Read",7="Insert/Modify/Read"
  168. PrivilegeType:Values2=15="Delete/Insert/Modify/Read",31="All Rights",255=
  169. FamilyRightsType:Values=Closed,0="None",1="Form",2="Reports",4="Validity Checks",8="Settings"
  170.  
  171. MSACCESS:Objects=O:C:0M::"Tables":Table
  172.  
  173. Table:Dataset1=NAME=String:261,FILENAME=String:261,EXTENSION=String:4,TYPE=String:32
  174. Table:Dataset2=DATE=Date,TIME=Time,SIZE=Integer,VIEW=Word,SYNONYM=Word
  175. Table:Dataset3=STRUCTURE=String:32,VERSION=Word,RECORDSIZE=Word,FIELDS=Word
  176. Table:Dataset4=INDEXES=Word,VALCHECKS=Word,REFCHECKS=Word,RECORDS=Integer
  177. Table:Dataset5=PROTECTED=Word,VALID=Word
  178.  
  179. Table:Category=Dataset
  180. Table:Attrs1=TYPE="Type"::NR:::VM=DriverType
  181. Table:Attrs2=DATE="Date"
  182. Table:Attrs3=TIME="Time"
  183. Table:Attrs4=VERSION="Version":2
  184. Table:Attrs5=VALID="Valid":2::::VM=BooleanYN
  185. Table:Attrs6=STRUCTURE="Structure":2
  186. Table:Attrs7=PROTECTED="Protected":2::::VM=BooleanYN
  187. Table:Name=FILENAME,EXTENSION
  188. Table:Objects1=O:P:1M::"Fields":Column
  189. Table:Objects2=O:O:0M::"Indices":Index
  190. Table:Objects3=O:O:0M::"Validity Checks":ValCheck
  191. Table:Objects4=O:O:0M::"Referential Constraints":Reference
  192. Table:Objects5=O:O:0M::"Security Specs":Security
  193.  
  194. Column:Dataset1=FIELDNUM=Word,NAME=String:32,TYPE=Word,SUBTYPE=Word
  195. Column:Dataset2=UNITS1=SmallInt,UNITS2=SmallInt,OFFSET=Word,LENGTH=Word
  196. Column:Dataset3=NULLOFFSET=Word,VCheck=Word,Rights=Word,CALCFIELD=Boolean
  197.  
  198. Column:Category=Column
  199. Column:Attrs1=TYPE="Type":1:NR,UNITS1="Size":1:N,UNITS2="Scale":1:N
  200. Column:Attrs2=LENGTH="Physical Length"
  201. Column:Name=NAME
  202.  
  203. Index:Dataset1=NAME=String:261,INDEXID=Word,TAGNAME=String:32,FORMAT=String:32
  204. Index:Dataset2=PRIMARY=Boolean,UNIQUE=Boolean,DESCENDING=Boolean,AUTO=Boolean
  205. Index:Dataset3=SUBSET=Boolean,KEYISEXP=Boolean,COST=Word,FIELDS=Word,KEYLEN=Word
  206. Index:Dataset4=OUTOFDATE=Boolean,EXPTYPE=Word,FIELDARRAY=Bytes:32
  207. Index:Dataset5=EXPRESSION=String:221,CONDITION=String:221,CASEINSENSITIVE=Boolean
  208. Index:Dataset6=BLOCKSIZE=Word,RESTRNUM=Word,DESCENDINGARRAY=Bytes:32
  209.  
  210. Index:Category=Index
  211. Index:Attrs1=NAME=Name:0,TAGNAME=Tag:0,RESTRNUM="Version":2
  212. Index:Attrs2=PRIMARY="Primary Key":::::VM=BooleanYN
  213. Index:Attrs3=UNIQUE="Unique"::NR:::VM=BooleanYN
  214. Index:Attrs4=AUTO="Maintained":2::::VM=BooleanYN
  215. Index:Attrs5=OUTOFDATE="Out of Date":2::::VM=BooleanYN
  216. Index:Attrs6=FORMAT="Format":2
  217. Index:Attrs7=BLOCKSIZE="Block Size":2
  218. Index:Attrs8=CASEINSENSITIVE="Case Insensitive":2:NR:::VM=BooleanYN
  219. Index:Attrs9=DESCENDING="Descending":2:NR:::VM=BooleanYN
  220. Index:Attrs10=EXPRESSION="Expression":2:N
  221. Index:Attrs11=CONDITION="Subset Condition":2:N
  222. Index:Name=NAME
  223. Index:OnAfterLoad=GetIndexInfo
  224.  
  225. ValCheck:Dataset1=FIELDNUM=Word,REQUIRED=Boolean,HASMINVAL=Boolean
  226. ValCheck:Dataset2=HASMAXVAL=Boolean,HASDEFVAL=Boolean,MINVALUE=String:256
  227. ValCheck:Dataset3=MAXVALUE=String:256,DEFAULT=String:256,PICTURE=String:176
  228. ValCheck:Dataset4=LOOKUPTYPE=Integer,LOOKUPTABLE=String:261
  229.  
  230. ValCheck:Attrs1=FIELDNUM="Field":2:NR
  231. ValCheck:Attrs2=REQUIRED="Required":1:NR:::VM=BooleanYN
  232. ValCheck:Attrs3=MINVALUE="Min Value":1:N
  233. ValCheck:Attrs4=MAXVALUE="Max Value":1:N
  234. ValCheck:Attrs5=DEFAULT="Default Value":1:N
  235. ValCheck:Attrs6=PICTURE="Picture":2:N
  236. ValCheck:Name=FIELDNUM
  237.  
  238. Reference:Dataset1=REFINTNUM=Word,NAME=String:32,TYPE=Integer
  239. Reference:Dataset2=OTHERTABLE=String:261,MODOP=Integer,DELOP=Integer
  240. Reference:Dataset3=FIELDCOUNT=Word,FIELDARRAY=Bytes:32,OTHERFIELDARRAY=Bytes:32
  241.  
  242. Reference:Attrs1=TYPE="Reference Type":1::::VM=ReferenceType
  243. Reference:Attrs2=OTHERTABLE="Reference To":1:NR
  244. Reference:Attrs3=MODOP="Modify Operation":1:NR:::VM=ReferenceQual
  245. Reference:Attrs4=DELOP="Delete Operation":1:NR:::VM=ReferenceQual
  246. Reference:Name=NAME
  247. Reference:OnAfterLoad=GetReferenceInfo
  248.  
  249. Security:Dataset1=ID=Word,TYPE=Integer,FAMRIGHTS=Word,PASSWORD=String:32
  250. Security:Dataset2=FIELDPRVARRAY=Bytes:1020
  251.  
  252. Security:Attrs1=TYPE="Table Rights":1:NR:::VM=PrivilegeType
  253. Security:Attrs2=FAMRIGHTS="Family Rights":1:NR:::VS=FamilyRightsType:$0F
  254. Security:Name=PASSWORD
  255.  
  256. [ODBC Properties]
  257. DriverType:Values=Closed,PARADOX="Paradox",DBASE="dBase",FOXPRO="FoxPro"
  258. BooleanYN:Values=Closed,0="No",-1="Yes",1="Yes"
  259. FieldVChecks:Values=Closed,0=,1="Has Validity Checks",2=
  260. FieldRights:Values=Closed,0="Read/Write",1="Read Only",2="None",3=
  261. LookupType:Values1=Closed,0="None",1="Current Field",2="All Corresponding"
  262. LookupType:Values2=3="Current Field & Help",4="All Corresponding & Help"
  263. ReferenceType:Values=Closed,0="Master Of",1="Detail Of"
  264. ReferenceQual:Values=Closed,0="Restrict",1="Cascade"
  265. PrivilegeType:Values1=Closed,0="None",1="Read Only",3="Modify/Read",7="Insert/Modify/Read"
  266. PrivilegeType:Values2=15="Delete/Insert/Modify/Read",31="All Rights",255=
  267. FamilyRightsType:Values=Closed,0="None",1="Form",2="Reports",4="Validity Checks",8="Settings"
  268.  
  269. ODBC:Objects1=O:C:0M::"Tables":Table
  270. ODBC:Objects2=O:C:0M::"Procedures":Procedure
  271.  
  272. Table:Dataset1=NAME=String:261,FILENAME=String:261,EXTENSION=String:4,TYPE=String:32
  273. Table:Dataset2=DATE=Date,TIME=Time,SIZE=Integer,VIEW=Word,SYNONYM=Word
  274. Table:Dataset3=STRUCTURE=String:32,VERSION=Word,RECORDSIZE=Word,FIELDS=Word
  275. Table:Dataset4=INDEXES=Word,VALCHECKS=Word,REFCHECKS=Word,RECORDS=Integer
  276. Table:Dataset5=PROTECTED=Word,VALID=Word
  277.  
  278. Table:Category=Dataset
  279. Table:Attrs1=TYPE="Type"::NR:::VM=DriverType
  280. Table:Attrs2=DATE="Date"
  281. Table:Attrs3=TIME="Time"
  282. Table:Attrs4=VERSION="Version":2
  283. Table:Attrs5=VALID="Valid":2::::VM=BooleanYN
  284. Table:Attrs6=STRUCTURE="Structure":2
  285. Table:Attrs7=PROTECTED="Protected":2::::VM=BooleanYN
  286. Table:Name=FILENAME,EXTENSION
  287. Table:Objects1=O:P:1M::"Fields":Column
  288. Table:Objects2=O:O:0M::"Indices":Index
  289. Table:Objects3=O:O:0M::"Validity Checks":ValCheck
  290. Table:Objects4=O:O:0M::"Referential Constraints":Reference
  291. Table:Objects5=O:O:0M::"Security Specs":Security
  292.  
  293. Column:Dataset1=FIELDNUM=Word,NAME=String:32,TYPE=Word,SUBTYPE=Word
  294. Column:Dataset2=UNITS1=SmallInt,UNITS2=SmallInt,OFFSET=Word,LENGTH=Word
  295. Column:Dataset3=NULLOFFSET=Word,VCheck=Word,Rights=Word,CALCFIELD=Boolean
  296.  
  297. Column:Category=Column
  298. Column:Order=FIELDNUM
  299. Column:Attrs1=FIELDNUM="Order":2:NR
  300. Column:Attrs2=TYPE="Type":1:NR
  301. Column:Attrs3=UNITS1="Size":1:N
  302. Column:Attrs4=UNITS2="Scale":1:N
  303. Column:Attrs5=LENGTH="Physical Length"
  304. Column:Name=NAME
  305.  
  306. Index:Dataset1=NAME=String:261,INDEXID=Word,TAGNAME=String:32,FORMAT=String:32
  307. Index:Dataset2=PRIMARY=Boolean,UNIQUE=Boolean,DESCENDING=Boolean,AUTO=Boolean
  308. Index:Dataset3=SUBSET=Boolean,KEYISEXP=Boolean,COST=Word,FIELDS=Word,KEYLEN=Word
  309. Index:Dataset4=OUTOFDATE=Boolean,EXPTYPE=Word,FIELDARRAY=Bytes:32
  310. Index:Dataset5=EXPRESSION=String:221,CONDITION=String:221,CASEINSENSITIVE=Boolean
  311. Index:Dataset6=BLOCKSIZE=Word,RESTRNUM=Word,DESCENDINGARRAY=Bytes:32
  312.  
  313. Index:Category=Index
  314. Index:Attrs1=NAME=Name:0,TAGNAME=Tag:0,RESTRNUM="Version":2
  315. Index:Attrs2=PRIMARY="Primary Key":::::VM=BooleanYN
  316. Index:Attrs3=UNIQUE="Unique"::NR:::VM=BooleanYN
  317. Index:Attrs4=AUTO="Maintained":2::::VM=BooleanYN
  318. Index:Attrs5=OUTOFDATE="Out of Date":2::::VM=BooleanYN
  319. Index:Attrs6=FORMAT="Format":2
  320. Index:Attrs7=BLOCKSIZE="Block Size":2
  321. Index:Attrs8=CASEINSENSITIVE="Case Insensitive":2:NR:::VM=BooleanYN
  322. Index:Attrs9=DESCENDING="Descending":2:NR:::VM=BooleanYN
  323. Index:Attrs10=EXPRESSION="Expression":2:N
  324. Index:Attrs11=CONDITION="Subset Condition":2:N
  325. Index:Name=NAME
  326. Index:OnAfterLoad=GetIndexInfo
  327.  
  328. ValCheck:Dataset1=FIELDNUM=Word,REQUIRED=Boolean,HASMINVAL=Boolean
  329. ValCheck:Dataset2=HASMAXVAL=Boolean,HASDEFVAL=Boolean,MINVALUE=String:256
  330. ValCheck:Dataset3=MAXVALUE=String:256,DEFAULT=String:256,PICTURE=String:176
  331. ValCheck:Dataset4=LOOKUPTYPE=Integer,LOOKUPTABLE=String:261
  332.  
  333. ValCheck:Attrs1=FIELDNUM="Field":2:NR
  334. ValCheck:Attrs2=REQUIRED="Required":1:NR:::VM=BooleanYN
  335. ValCheck:Attrs3=MINVALUE="Min Value":1:N
  336. ValCheck:Attrs4=MAXVALUE="Max Value":1:N
  337. ValCheck:Attrs5=DEFAULT="Default Value":1:N
  338. ValCheck:Attrs6=PICTURE="Picture":2:N
  339. ValCheck:Name=FIELDNUM
  340.  
  341. Reference:Dataset1=REFINTNUM=Word,NAME=String:32,TYPE=Integer
  342. Reference:Dataset2=OTHERTABLE=String:261,MODOP=Integer,DELOP=Integer
  343. Reference:Dataset3=FIELDCOUNT=Word,FIELDARRAY=Bytes:32,OTHERFIELDARRAY=Bytes:32
  344.  
  345. Reference:Attrs1=TYPE="Reference Type":1::::VM=ReferenceType
  346. Reference:Attrs2=OTHERTABLE="Reference To":1:NR
  347. Reference:Attrs3=MODOP="Modify Operation":1:NR:::VM=ReferenceQual
  348. Reference:Attrs4=DELOP="Delete Operation":1:NR:::VM=ReferenceQual
  349. Reference:Name=NAME
  350. Reference:OnAfterLoad=GetReferenceInfo
  351.  
  352. Security:Dataset1=ID=Word,TYPE=Integer,FAMRIGHTS=Word,PASSWORD=String:32
  353. Security:Dataset2=FIELDPRVARRAY=Bytes:1020
  354.  
  355. Security:Attrs1=TYPE="Table Rights":1:NR:::VM=PrivilegeType
  356. Security:Attrs2=FAMRIGHTS="Family Rights":1:NR:::VS=FamilyRightsType:$0F
  357. Security:Name=PASSWORD
  358.  
  359. Procedure:Dataset=NAME=String,DATE=Date,TIME=Time
  360.  
  361. Procedure:Category=Executable
  362. Procedure:Attrs=DATE="Date":1,TIME="Time":1
  363. Procedure:EAttrs=Data
  364. Procedure:Name=NAME
  365.  
  366.  
  367.  
  368.  
  369. [INTRBASE Properties]
  370. TFieldType:Values1=Closed,7=SMALLINT,8=INTEGER,9=QUAD,10=FLOAT
  371. TFieldType:Values2=11=DOUBLE PRECISION,14=`'CHAR('=Length')'`:CHAR,27=NUMERIC
  372. TFieldType:Values3=35=DATE,37=`'VARCHAR('=Length')'`:VARCHAR
  373. TFieldType:Values4=40=`'CSTRING('=Length')'`:CSTRING
  374. TFieldType:Values5=261=`'BLOB'``!' SUB_TYPE ' =SubType`:BLOB
  375. TFieldSubType:Values1=Closed,0=0:,1=1:"Text",2=2:"BLR",3=3:"ACL",4=4:"Ranges",5=5:"Summary"
  376. TFieldSubType:Values2=6=6:"Format",7=7:"Transaction Desc",8=8:"Ext File Desc"
  377. TNulls:Values=Closed,=:"Yes",1=NOT NULL:"No"
  378. TUniqueIndex:Values=Closed,=:"No",0=:"No",1=UNIQUE:"Yes"
  379. TDescendingIndex:Values=Closed,=ASCENDING:"No",1=DESCENDING:"Yes"
  380. TTriggerType:Values1=Closed,1=BEFORE INSERT,2=AFTER INSERT,3=BEFORE UPDATE
  381. TTriggerType:Values2=4=AFTER UPDATE,5=BEFORE DELETE,6=AFTER DELETE
  382. TParamKind:Values=Closed,0=:"Input",1=:"Output"
  383. TFnParamKind:Values=Closed,0=BY VALUE:"Value",1=:"Reference",3=:"Handle"
  384.  
  385. INTRBASE:Comments=/*,*/
  386.  
  387. INTRBASE:Objects1=O:C:0M::"Domains":Type
  388. INTRBASE:Objects2=O:C:0M::"Tables":Table
  389. INTRBASE:Objects3=O:C:0M::"Views":View
  390. INTRBASE:Objects4=O:C:0M::"Procedures":Procedure
  391. INTRBASE:Objects5=O:C:0M::"Functions":Function
  392. INTRBASE:Objects6=O:C:0M::"Generators":Generator
  393. INTRBASE:Objects7=O:C:0M::"Exceptions":Exception
  394. INTRBASE:Objects8=O:C:0M::"Blob Filters":BlobFilter
  395.  
  396. RDB$RELATIONS:Name=RDB$RELATION_NAME
  397. RDB$RELATIONS:Attrs1=RDB$OWNER_NAME="Owner"
  398. RDB$RELATIONS:Attrs2=RDB$DESCRIPTION="Description"
  399. RDB$RELATIONS:FilterSystemObjects=A.RDB$SYSTEM_FLAG <> 1 or A.RDB$SYSTEM_FLAG IS NULL
  400.  
  401. RDB$RELATION_FIELDS:Key=RDB$RELATION_NAME,RDB$FIELD_NAME
  402. RDB$RELATION_FIELDS:Name=RDB$FIELD_NAME
  403. RDB$RELATION_FIELDS:Order=RDB$FIELD_POSITION
  404. RDB$RELATION_FIELDS:Objects=P:R:M1::"Domain":Type
  405. RDB$RELATION_FIELDS:Attrs1=RDB$FIELD_POSITION="Order":2:ER
  406. RDB$RELATION_FIELDS:Attrs2=RDB$DEFAULT_SOURCE=Default="Default"::E
  407. RDB$RELATION_FIELDS:Attrs3=RDB$NULL_FLAG=Null="Nulls"::E:::VM=TNulls
  408. RDB$RELATION_FIELDS:Reference:"Domain"=RDB$FIELD_SOURCE
  409.  
  410. RDB$FIELDS:Name=RDB$FIELD_NAME
  411. RDB$FIELDS:Attrs1=RDB$FIELD_TYPE=FieldType="Type"::ER:::VM=TFieldType
  412. RDB$FIELDS:Attrs2=RDB$FIELD_SUB_TYPE=SubType="Subtype"::E:::VM=TFieldSubType
  413. RDB$FIELDS:Attrs3=RDB$FIELD_LENGTH=Length="Length"::E
  414. RDB$FIELDS:Attrs4=RDB$FIELD_SCALE=Scale="Scale"::E
  415. RDB$FIELDS:Attrs5=RDB$NULL_FLAG=Null="Nulls"::E:::VM=TNulls
  416. RDB$FIELDS:Attrs6=RDB$SEGMENT_LENGTH=SegmentSize="Segment Size":2:E
  417. RDB$FIELDS:Attrs7=RDB$DEFAULT_SOURCE=Default="Default":2:E
  418. RDB$FIELDS:Attrs8=RDB$VALIDATION_SOURCE=Rule="Constraint":2:E
  419. RDB$FIELDS:Attrs9=RDB$DESCRIPTION=Description="Description"
  420.  
  421. RDB$FIELD_DIMENSIONS:Key=RDB$FIELD_NAME,RDB$DIMENSION
  422. RDB$FIELD_DIMENSIONS:Name=RDB$DIMENSION
  423. RDB$FIELD_DIMENSIONS:Order=RDB$DIMENSION
  424. RDB$FIELD_DIMENSIONS:Attrs1=RDB$DIMENSION="Order":2:ER
  425. RDB$FIELD_DIMENSIONS:Attrs2=RDB$LOWER_BOUND=LowerBound="Lower Bound"::ER
  426. RDB$FIELD_DIMENSIONS:Attrs3=RDB$UPPER_BOUND=UpperBound="Upper Bound"::ER
  427.  
  428. RDB$FUNCTIONS:Name=RDB$FUNCTION_NAME
  429. RDB$FUNCTIONS:Attrs1=RDB$MODULE_NAME=Module="Module"::ER
  430. RDB$FUNCTIONS:Attrs2=RDB$ENTRYPOINT=Entry="Entry"::ER
  431. RDB$FUNCTIONS:Attrs3=RDB$QUERY_NAME=AlternateName="Alternate Name"
  432. RDB$FUNCTIONS:Attrs4=RDB$DESCRIPTION=Description="Description":2
  433. RDB$FUNCTIONS:FilterSystemObjects=A.RDB$SYSTEM_FLAG <> 1 or A.RDB$SYSTEM_FLAG IS NULL
  434.  
  435. RDB$FUNCTION_ARGUMENTS:Key=RDB$FUNCTION_NAME,RDB$ARGUMENT_POSITION
  436. RDB$FUNCTION_ARGUMENTS:Name=RDB$ARGUMENT_POSITION
  437. RDB$FUNCTION_ARGUMENTS:Order=RDB$ARGUMENT_POSITION
  438. RDB$FUNCTION_ARGUMENTS:Attrs1=RDB$ARGUMENT_POSITION="Order":2:ER
  439. RDB$FUNCTION_ARGUMENTS:Attrs2=RDB$FIELD_TYPE=FieldType="Type"::ER:::VM=TFieldType
  440. RDB$FUNCTION_ARGUMENTS:Attrs3=RDB$FIELD_SUB_TYPE=SubType="Subtype"::E:::VM=TFieldSubType
  441. RDB$FUNCTION_ARGUMENTS:Attrs4=RDB$FIELD_LENGTH=Length="Length"::E
  442. RDB$FUNCTION_ARGUMENTS:Attrs5=RDB$FIELD_SCALE=Scale="Scale"::E
  443.  
  444. RDB$FILTERS:Name=RDB$FUNCTION_NAME
  445. RDB$FILTERS:Attrs1=RDB$MODULE_NAME=Module="Module"::ER
  446. RDB$FILTERS:Attrs2=RDB$ENTRYPOINT=Entry="Entry"::ER
  447. RDB$FILTERS:Attrs3=RDB$INPUT_SUB_TYPE=InputType="Input"::ER:::VM=TFieldSubType
  448. RDB$FILTERS:Attrs4=RDB$OUTPUT_SUB_TYPE=OutputType="Output"::ER:::VM=TFieldSubType
  449. RDB$FILTERS:Attrs5=RDB$DESCRIPTION=Description="Description":2
  450. RDB$FILTERS:FilterSystemObjects=A.RDB$SYSTEM_FLAG <> 1 or A.RDB$SYSTEM_FLAG IS NULL
  451.  
  452. RDB$INDICES:Name=RDB$INDEX_NAME
  453. RDB$INDICES:Objects=T:P:1M::"Columns":IndexColumn
  454. RDB$INDICES:Attrs1=RDB$UNIQUE_FLAG=Unique="Unique"::E:::VM=TUniqueIndex
  455. RDB$INDICES:Attrs2=RDB$INDEX_TYPE=Descending="Descending"::E:::VM=TDescendingIndex
  456. RDB$INDICES:FilterSystemObjects=A.RDB$SYSTEM_FLAG <> 1 or A.RDB$SYSTEM_FLAG IS NULL
  457.  
  458. RDB$INDEX_SEGMENTS:Key=RDB$INDEX_NAME,RDB$FIELD_NAME
  459. RDB$INDEX_SEGMENTS:Name=Column
  460. RDB$INDEX_SEGMENTS:Order=RDB$FIELD_POSITION
  461. RDB$INDEX_SEGMENTS:Objects1=P:R:M1::"Column":Column:<<>Column
  462. RDB$INDEX_SEGMENTS:Attrs1=RDB$FIELD_POSITION="Order":2:ER
  463. RDB$INDEX_SEGMENTS:Reference:"Column"=,RDB$FIELD_NAME
  464.  
  465. RDB$PROCEDURES:Name=RDB$PROCEDURE_NAME
  466. RDB$PROCEDURES:Attrs1=RDB$OWNER_NAME="Owner"
  467. RDB$PROCEDURES:FilterSystemObjects=A.RDB$SYSTEM_FLAG <> 1 or A.RDB$SYSTEM_FLAG IS NULL
  468.  
  469. RDB$PROCEDURE_PARAMETERS:Key=RDB$PROCEDURE_NAME,RDB$PARAMETER_NAME
  470. RDB$PROCEDURE_PARAMETERS:Name=RDB$PARAMETER_NAME
  471. RDB$PROCEDURE_PARAMETERS:Order=RDB$PARAMETER_NUMBER
  472. RDB$PROCEDURE_PARAMETERS:Objects=P:R:M1::"Domain":Type
  473. RDB$PROCEDURE_PARAMETERS:Attrs1=RDB$PARAMETER_NUMBER="Order":2
  474. RDB$PROCEDURE_PARAMETERS:Attrs2=RDB$PARAMETER_TYPE=Kind="Kind":1:ER:::VM=TParamKind
  475. RDB$PROCEDURE_PARAMETERS:Reference:"Domain"=RDB$FIELD_SOURCE
  476.  
  477. RDB$TYPES:Key=RDB$FIELD_NAME,RDB$TYPE
  478. RDB$TYPES:Name=RDB$TYPE_NAME
  479. RDB$TYPES:Order=RDB$TYPE
  480. RDB$TYPES:Attrs=RDB$TYPE="Value"
  481.  
  482. RDB$GENERATORS:Name=RDB$GENERATOR_NAME
  483. RDB$GENERATORS:FilterSystemObjects=A.RDB$SYSTEM_FLAG <> 1 or A.RDB$SYSTEM_FLAG IS NULL
  484.  
  485. RDB$EXCEPTIONS:Name=RDB$EXCEPTION_NAME
  486. RDB$EXCEPTIONS:Attrs1=RDB$MESSAGE=Message="Message"::E
  487.  
  488. RDB$TRIGGERS:Key=RDB$RELATION_NAME,RDB$TRIGGER_NAME
  489. RDB$TRIGGERS:Name=RDB$TRIGGER_NAME
  490. RDB$TRIGGERS:Attrs1=RDB$TRIGGER_TYPE=Type="Type"::ER:::VM=TTriggerType
  491. RDB$TRIGGERS:Attrs2=RDB$TRIGGER_SEQUENCE=Position="Position"::ER
  492. RDB$TRIGGERS:FilterSystemObjects=A.RDB$SYSTEM_FLAG <> 1 or A.RDB$SYSTEM_FLAG IS NULL
  493.  
  494. RDB$RELATION_CONSTRAINTS:Key=RDB$RELATION_NAME,RDB$CONSTRAINT_NAME
  495. RDB$RELATION_CONSTRAINTS:Name=RDB$CONSTRAINT_NAME
  496. RDB$RELATION_CONSTRAINTS:Attrs1=RDB$DEFERRABLE="Can Defer"
  497. RDB$RELATION_CONSTRAINTS:Attrs2=RDB$INITIALLY_DEFERRED="Initially Deferred"
  498. RDB$RELATION_CONSTRAINTS:Reference:"Columns"=RDB$INDEX_NAME
  499.  
  500. RDB$REF_CONSTRAINTS:Name=RDB$CONSTRAINT_NAME
  501. RDB$REF_CONSTRAINTS:Objects1=P:R:01::"Primary Key":PrimaryKey
  502. RDB$REF_CONSTRAINTS:Objects2=P:R:11::"Foreign Key":ForeignKey
  503. RDB$REF_CONSTRAINTS:Attrs1=RDB$CONSTRAINT_NAME="Foreign Key"
  504. RDB$REF_CONSTRAINTS:Attrs2=RDB$CONST_NAME_UQ="Primary Key"
  505. RDB$REF_CONSTRAINTS:Attrs3=RDB$MATCH_OPTION="Match Option"
  506. RDB$REF_CONSTRAINTS:Attrs4=RDB$UPDATE_RULE="Update Rule"
  507. RDB$REF_CONSTRAINTS:Attrs5=RDB$DELETE_RULE="Delete Rule"
  508. RDB$REF_CONSTRAINTS:Reference:"PrimaryKey"=RDB$CONST_NAME_UQ=RDB$CONSTRAINT_NAME
  509. RDB$REF_CONSTRAINTS:Reference:"ForeignKey"=RDB$CONSTRAINT_NAME=RDB$CONSTRAINT_NAME
  510.  
  511. RDB$CHECK_CONSTRAINTS:Name=RDB$CONSTRAINT_NAME
  512. RDB$CHECK_CONSTRAINTS:Attrs=RDB$TRIGGER_NAME="Trigger"
  513.  
  514. Table:Definition=Root=RDB$RELATIONS
  515. View:Definition=Root=RDB$RELATIONS
  516. Procedure:Definition=Root=RDB$PROCEDURES
  517. Function:Definition=Root=RDB$FUNCTIONS
  518. Trigger:Definition=Root=RDB$TRIGGERS
  519. PrimaryKey:Definition=Root=RDB$RELATION_CONSTRAINTS
  520. ForeignKey:Definition=Root=RDB$RELATION_CONSTRAINTS
  521. UniqueConstraint:Definition=Root=RDB$RELATION_CONSTRAINTS
  522. CheckConstraint:Definition=Root=RDB$RELATION_CONSTRAINTS
  523. Exception:Definition=Root=RDB$EXCEPTIONS
  524. Generator:Definition=Root=RDB$GENERATORS
  525. Index:Definition=Root=RDB$INDICES
  526. IndexColumn:Definition=Root=RDB$INDEX_SEGMENTS
  527. Column:Definition=Root=RDB$RELATION_FIELDS
  528. Type:Definition=Root=RDB$FIELDS
  529. Enumeration:Definition=Root=RDB$TYPES
  530. Parameter:Definition=Root=RDB$PROCEDURE_PARAMETERS
  531. FunctionParameter:Definition=Root=RDB$FUNCTION_ARGUMENTS
  532. FunctionResult:Definition=Root=RDB$FUNCTION_ARGUMENTS
  533. BlobFilter:Definition=Root=RDB$FILTERS
  534. Dimension:Definition=Root=RDB$FIELD_DIMENSIONS
  535.  
  536. Exception:Warning=Loss
  537. Exception:EAttrs=Text,New,Delete,Modify,Rename,Save
  538. Exception:Text:Get=CREATE EXCEPTION `\N '  ' N \N`  "`=Message`"
  539. Exception:Text:RE=CREATE EXCEPTION\_+(\w+)\_+"(.*)"
  540. Exception:Text:Set=*N=1,Message=2
  541. Exception:Delete:Text=DROP EXCEPTION `O`
  542.  
  543. Generator:Attrs:Q=gen_id=Integer::"Current Value":2:ER
  544. Generator:AttrReference:gen_id=select distinct gen_id(`O`, 0) from RDB$GENERATORS
  545. Generator:Warning=Loss
  546. Generator:EAttrs=Text,New:';',Delete,Modify,Rename,Save
  547. Generator:Text:Init1=CREATE GENERATOR `EDefaultName ';' \N`
  548. Generator:Text:Init2=SET GENERATOR `EDefaultName` TO 0
  549. Generator:Text:Get=CREATE GENERATOR `N`;`\N 'SET GENERATOR ' N ' TO ' =gen_id`
  550. Generator:Text:RE=CREATE GENERATOR\_+(\w+);(\_*SET GENERATOR \w+ TO (\w*))?\_*$
  551. Generator:Text:Set=*N=1,gen_id=3
  552. Generator:Delete:Text1=DELETE FROM RDB$GENERATORS
  553. Generator:Delete:Text2=WHERE RDB$GENERATOR_NAME=`OQ`
  554.  
  555. Table:Category=Dataset
  556. Table:Values=A.RDB$VIEW_SOURCE IS NULL
  557. Table:Objects1=T:P:1M::"Columns":Column
  558. Table:Objects2=T:O:0M::"Indices":Index
  559. Table:Objects3=T:O:01::"Primary Key":PrimaryKey
  560. Table:Objects4=T:O:0M::"Referential Constraints":ForeignKey
  561. Table:Objects5=T:O:0M::"Unique Constraints":UniqueConstraint
  562. Table:Objects6=T:O:0M::"Check Constraints":CheckConstraint
  563. Table:Objects7=T:O:0M::"Triggers":Trigger
  564. Table:Reference:"Indices"=RDB$RELATION_NAME=RDB$RELATION_NAME
  565. Table:Warning=DataLoss
  566. Table:EAttrs=Data,Text,New,Delete,Modify,Rename,Save
  567. Table:Text:Get=CREATE TABLE `N` (`[Column:%s,%s:\N '  ' *] \N`)
  568. Table:Text:RE=CREATE TABLE\_+(\w+)\_*(\(.*\))
  569. Table:Text:Set=*N=1
  570. Table:Delete:Text=DROP TABLE `O`
  571.  
  572. View:Category=Dataset
  573. View:Values=A.RDB$VIEW_SOURCE IS NOT NULL
  574. View:Objects=T:P:0M:NMDR:"Columns":Column
  575. View:Attrs:Q=Text=Memo::"Text"::ER
  576. View:AttrReference:Text1=select RDB$VIEW_SOURCE from RDB$RELATIONS
  577. View:AttrReference:Text2=where RDB$RELATION_ID=`:RDB$RELATION_ID`
  578. View:Warning=Loss
  579. View:EAttrs=Data,Text,New,Modify,Rename,Delete,Save
  580. View:Text:Init=CREATE VIEW `EDefaultName` AS SELECT
  581. View:Text:Get=CREATE VIEW `N` `'('[Column:%s,%s:\N '  ' N] \N ') '`AS`=Text`
  582. View:Text:RE=CREATE VIEW\_+(\w+)\_*(\(.*\))?\_+AS(.*)
  583. View:Text:Set=Text=3,*N=1
  584. View:Delete:Text=DROP VIEW `O`
  585.  
  586. Index:Category=Index
  587. Index:EAttrs=Text,New,Delete,Modify,Rename,Save
  588. Index:Text:Get1=CREATE `!=Unique ' ' ``!=Descending ' ' `INDEX `N`
  589. Index:Text:Get2=ON `{<}N` (`[IndexColumn:%s, %s:*]`)
  590. Index:Text:RE=CREATE.*\_INDEX\_+(\w+)\_+ON\_+(\w+).*(\(.*\))
  591. Index:Text:Set=*N=1,2=`{<}N`,*>IndexColumn=3
  592. Index:Delete:Text=DROP INDEX `O`
  593.  
  594. Column:Category=Column
  595. Column:Attrs:T1=RDB$FIELDS.RDB$FIELD_TYPE=FieldType:"Type":"Default":1:E::PResetType
  596. Column:Attrs:T2=RDB$FIELDS.RDB$FIELD_SUB_TYPE=SubType:"Subtype":"Default":1:E::PResetType
  597. Column:Attrs:T3=RDB$FIELDS.RDB$FIELD_LENGTH=Length:"Length":"Default":1:E::PResetType
  598. Column:Attrs:T4=RDB$FIELDS.RDB$FIELD_SCALE=Scale:"Scale":"Default":1:E::PResetType
  599. Column:Attrs:R=Type:"Domain":"Type":1:E::PSetType
  600. Column:OnAfterLoad=ColumnLoaded
  601. Column:OnCopyFrom=CopyWithDomain
  602. Column:AttrReference:FieldType=RDB$FIELD_SOURCE
  603. Column:AttrReference:SubType=RDB$FIELD_SOURCE
  604. Column:AttrReference:Length=RDB$FIELD_SOURCE
  605. Column:AttrReference:Scale=RDB$FIELD_SOURCE
  606. Column:EAttrs=Text,New,Delete,Modify,Rename
  607. Column:Text:Get=`N ' ' EType``! ' DEFAULT ' =Default``! ' ' =Null`
  608.  
  609. IndexColumn:Category=ColumnReference
  610. IndexColumn:Attrs:R=Column:::2:ER
  611. IndexColumn:EAttrs=Text,New,Delete,Modify,Rename
  612. IndexColumn:Text:Get=`N`
  613.  
  614. Type:Category=Type
  615. Type:Objects1=T:P:0M::"Dimensions":Dimension
  616. Type:Objects2=T:C:0M::"Values":Enumeration
  617. ; Convert DEFAULT (.*) in Default and CHECK \((.*)\) in Rule
  618. Type:OnAfterLoad=TypeLoaded
  619. Type:Reference:"Dimensions":Text=`' [' [Dimension:%s, %s:*] ']'`
  620. Type:Warning=Loss
  621. Type:EAttrs=Text,New,Delete,Modify,Rename,Save
  622. Type:Text:Get1=CREATE DOMAIN `N` AS` \N '  ' EPhysicalType`
  623. Type:Text:Get2=`!\N '  DEFAULT '=Default`
  624. Type:Text:Get3=`!\N '  ' =Null`
  625. Type:Text:Get4=`!\N '  CHECK (' =Rule ')'`
  626. Type:Delete:Text=DROP DOMAIN `O`
  627.  
  628. Dimension:EAttrs=Text,New,Delete,Modify,Rename
  629. Dimension:Text:Get=`=LowerBound ':' =UpperBound`
  630.  
  631. Procedure:Category=Executable
  632. Procedure:Objects=T:P:0M::"Parameters":Parameter
  633. Procedure:Reference:"Parameters":Text1=`!'(' \N {>Parameter} EParametersIn \N')'`
  634. Procedure:Reference:"Parameters":Text2=`!'RETURNS (' \N {>Parameter} EParametersOut \N ')'`
  635. Procedure:Attrs:Q=Text=Memo::"Text"::ER
  636. Procedure:AttrReference:Text1=select RDB$PROCEDURE_SOURCE from RDB$PROCEDURES
  637. Procedure:AttrReference:Text2=where RDB$PROCEDURE_NAME=`OQ`
  638. Procedure:Warning=Loss
  639. Procedure:EAttrs=Data,Text,New,Delete,Modify,Rename,Save
  640. Procedure:Text:Init=CREATE PROCEDURE `EDefaultName` AS`\N`BEGIN`\N`END
  641. Procedure:Text:Get1=CREATE PROCEDURE `N`
  642. Procedure:Text:Get2=`{>Parameter} *`
  643. Procedure:Text:Get3=AS `=Text`
  644. Procedure:Text:RE=CREATE PROCEDURE\_+(\w+)\_*(.*)\_AS\_(.*)
  645. Procedure:Text:Set=Text=3,*>Parameter=2,*N=1
  646. Procedure:Modify:RE=(CREATE)\_+PROCEDURE
  647. Procedure:Modify:Set=1=`'ALTER'`
  648. Procedure:Delete:Text=DROP PROCEDURE `O`
  649.  
  650. Parameter:Category=Column
  651. Parameter:Attrs:T1=RDB$FIELDS.RDB$FIELD_TYPE=FieldType:"Type":"Default":1:-E::PResetType
  652. Parameter:Attrs:T2=RDB$FIELDS.RDB$FIELD_SUB_TYPE=SubType:"Subtype":"Default":1:-E::PResetType
  653. Parameter:Attrs:T3=RDB$FIELDS.RDB$FIELD_LENGTH=Length:"Length":"Default":1:-E::PResetType
  654. Parameter:Attrs:T4=RDB$FIELDS.RDB$FIELD_SCALE=Scale:"Scale":"Default":1:-E::PResetType
  655. Parameter:Attrs:R=Type:"Domain":"Type":1:::PSetType
  656. Parameter:AttrReference:FieldType=RDB$FIELD_SOURCE
  657. Parameter:AttrReference:SubType=RDB$FIELD_SOURCE
  658. Parameter:AttrReference:Length=RDB$FIELD_SOURCE
  659. Parameter:AttrReference:Scale=RDB$FIELD_SOURCE
  660. Parameter:EAttrs=Text
  661. Parameter:Text:Get=`N ' ' EType`
  662. Parameter:OnAfterLoad=AdjustTypeInfo
  663. Parameter:OnCopyFrom=CopyWithDomain
  664.  
  665. Function:Category=Executable
  666. Function:Objects1=T:P:0M::"Parameters":FunctionParameter
  667. Function:Objects2=T:P:11::"Result":FunctionResult
  668. Function:Reference:"Parameters":Text=`[FunctionParameter:%s, %s:*]`
  669. Function:Reference:"Result":Text=`[FunctionResult::*]`
  670. Function:Warning=Loss
  671. Function:EAttrs=Text,New,Delete,Modify,Rename,Save
  672. Function:Text:Get1=DECLARE EXTERNAL FUNCTION `N \N`
  673. Function:Text:Get2=`!'  ' {>FunctionParameter} * \N`
  674. Function:Text:Get3=`'  RETURNS ' {>FunctionResult} * \N`
  675. Function:Text:Get4= ENTRY_POINT "`=Entry`"  MODULE_NAME "`=Module`"
  676. Function:Delete:Text=DROP EXTERNAL FUNCTION `O`
  677.  
  678. FunctionParameter:Category=Column
  679. FunctionParameter:Values=A.RDB$ARGUMENT_POSITION <> `:RDB$RETURN_ARGUMENT`
  680. FunctionParameter:EAttrs=Text,New,Delete,Modify,Rename
  681. FunctionParameter:Text:Get=`EPhysicalType`
  682.  
  683. FunctionResult:Category=Column
  684. FunctionResult:Values=A.RDB$ARGUMENT_POSITION = `:RDB$RETURN_ARGUMENT`
  685. FunctionResult:Attrs=RDB$MECHANISM=Kind="Kind"::E:::VM=TFnParamKind
  686. FunctionResult:EAttrs=Text,New,Delete,Modify,Rename
  687. FunctionResult:Text:Get=`EPhysicalType``! ' ' =Kind`
  688.  
  689. BlobFilter:Category=Executable
  690. BlobFilter:Warning=Loss
  691. BlobFilter:EAttrs=Text,New,Delete,Modify,Rename,Save
  692. BlobFilter:Text:Get1=DECLARE FILTER `N \N`
  693. BlobFilter:Text:Get2= INPUT_TYPE `=InputType`  OUTPUT_TYPE `=OutputType``\N`
  694. BlobFilter:Text:Get3= ENTRY_POINT "`=Entry`"  MODULE_NAME "`=Module`"
  695. BlobFilter:Delete:Text=DROP FILTER `O`
  696.  
  697. CheckConstraint:Category=Expression
  698. CheckConstraint:Values=A.RDB$CONSTRAINT_TYPE = 'CHECK'
  699. CheckConstraint:Attrs:Q=Text=Memo::"Constraint Text":2:ER:PStripCheck
  700. CheckConstraint:AttrReference:Text1=select t.RDB$TRIGGER_SOURCE
  701. CheckConstraint:AttrReference:Text2=from RDB$TRIGGERS t, RDB$CHECK_CONSTRAINTS c
  702. CheckConstraint:AttrReference:Text3=where t.RDB$TRIGGER_NAME=c.RDB$TRIGGER_NAME and
  703. CheckConstraint:AttrReference:Text4=t.RDB$TRIGGER_TYPE=1 and
  704. CheckConstraint:AttrReference:Text5=c.RDB$CONSTRAINT_NAME=`OQ`
  705. CheckConstraint:EAttrs=Text,New,Delete,Modify,Rename,Save
  706. CheckConstraint:Text:Init=ALTER TABLE `{<}N\N`  ADD CONSTRAINT `EDefaultName \N`  CHECK ()
  707. CheckConstraint:Text:Get=ALTER TABLE `{<}N\N`  ADD CONSTRAINT `N\N`  CHECK (`=Text`)
  708. CheckConstraint:Text:RE=ALTER\_+TABLE\_+(\w+)\_+ADD\_+CONSTRAINT\_+(\w+)\_+CHECK\_*\((.*)\)
  709. CheckConstraint:Text:Set=1=`{<}N`,Text=3,*N=2
  710. CheckConstraint:Delete:Text=ALTER TABLE `{<}O` DROP CONSTRAINT `O`
  711.  
  712. UniqueConstraint:Category=UniqueConstraint
  713. UniqueConstraint:Values=A.RDB$CONSTRAINT_TYPE = 'UNIQUE'
  714. UniqueConstraint:Objects1=T:P:1M::"Columns":IndexColumn
  715. UniqueConstraint:Objects2=P:R:M1::"Index":Index:<>Index
  716. UniqueConstraint:Reference:"Columns"=RDB$INDEX_NAME
  717. UniqueConstraint:Reference:"Index"=RDB$INDEX_NAME
  718. UniqueConstraint:EAttrs=Text,New,Delete,Modify,Rename,Save
  719. UniqueConstraint:Text:Get1=ALTER TABLE `{<}N\N`  ADD CONSTRAINT `N`
  720. UniqueConstraint:Text:Get2=`\N`  UNIQUE `'(' [IndexColumn:%s, %s:N] ')'`
  721. UniqueConstraint:Delete:Text=ALTER TABLE `{<}O` DROP CONSTRAINT `O`
  722.  
  723. PrimaryKey:Category=PrimaryKey
  724. PrimaryKey:Values=A.RDB$CONSTRAINT_TYPE = 'PRIMARY KEY'
  725. PrimaryKey:Objects1=T:P:1M::"Columns":IndexColumn
  726. PrimaryKey:Objects2=P:R:M1::"Index":Index:<>Index
  727. PrimaryKey:Reference:"Columns"=RDB$INDEX_NAME
  728. PrimaryKey:Reference:"Index"=RDB$INDEX_NAME
  729. PrimaryKey:EAttrs=Text,New,Delete,Modify,Rename,Save
  730. PrimaryKey:Text:Get1=ALTER TABLE `{<}N\N`  ADD CONSTRAINT `N`
  731. PrimaryKey:Text:Get2=`\N`  PRIMARY KEY `'(' [IndexColumn:%s, %s:N] ')'`
  732. PrimaryKey:Delete:Text=ALTER TABLE `{<}O` DROP CONSTRAINT `O`
  733.  
  734. ForeignKey:Category=ForeignKey
  735. ForeignKey:Values=A.RDB$CONSTRAINT_TYPE = 'FOREIGN KEY'
  736. ForeignKey:Objects1=P:R:M1::"Index":Index:<>Index
  737. ForeignKey:Objects2=T:P:1M::"Columns":IndexColumn
  738. ForeignKey:Objects3=P:R:M1::"Reference Table":Table
  739. ForeignKey:Reference:"Index"=RDB$INDEX_NAME
  740. ForeignKey:Reference:"Columns"=RDB$INDEX_NAME
  741. ForeignKey:Reference:"Reference Table"=ReferenceTable
  742. ForeignKey:Attrs:T1=RDB$REF_CONSTRAINTS.RDB$MATCH_OPTION=MatchOption
  743. ForeignKey:Attrs:T2=RDB$REF_CONSTRAINTS.RDB$UPDATE_RULE=UpdateRule
  744. ForeignKey:Attrs:T3=RDB$REF_CONSTRAINTS.RDB$DELETE_RULE=DeleteRule
  745. ForeignKey:Attrs:Q=ReferenceTable=String:::0
  746. ForeignKey:Attrs:R=Table::::ER
  747. ForeignKey:AttrReference:ReferenceTable1=select RDB$RELATION_NAME
  748. ForeignKey:AttrReference:ReferenceTable2=from RDB$REF_CONSTRAINTS A, RDB$RELATION_CONSTRAINTS B
  749. ForeignKey:AttrReference:ReferenceTable3=where A.RDB$CONST_NAME_UQ = B.RDB$CONSTRAINT_NAME
  750. ForeignKey:AttrReference:ReferenceTable4=and A.RDB$CONSTRAINT_NAME = `:RDB$CONSTRAINT_NAME`
  751. ForeignKey:AttrReference:MatchOption=RDB$CONSTRAINT_NAME=RDB$CONSTRAINT_NAME
  752. ForeignKey:AttrReference:UpdateRule=RDB$CONSTRAINT_NAME=RDB$CONSTRAINT_NAME
  753. ForeignKey:AttrReference:DeleteRule=RDB$CONSTRAINT_NAME=RDB$CONSTRAINT_NAME
  754. ForeignKey:EAttrs=Text,New,Delete,Modify,Rename,Save
  755. ForeignKey:Text:Get1=ALTER TABLE `{<}N\N`  ADD CONSTRAINT `N`
  756. ForeignKey:Text:Get2=`\N`  FOREIGN KEY `'(' [IndexColumn:%s, %s:N] ')'`
  757. ForeignKey:Text:Get3=`\N`  REFERENCES `=Table`
  758. ForeignKey:Delete:Text=ALTER TABLE `{<}O` DROP CONSTRAINT `O`
  759.  
  760. Trigger:Category=Executable
  761. Trigger:Attrs:Q=Text=Memo::"Text"::ER:PROOName
  762. Trigger:AttrReference:Text1=select RDB$TRIGGER_SOURCE from RDB$TRIGGERS
  763. Trigger:AttrReference:Text2=where RDB$TRIGGER_NAME=`OQ`
  764. Trigger:EAttrs=Text,New,Delete,Modify,Rename,Save
  765. Trigger:Text:Init1=CREATE TRIGGER `EDefaultName` FOR `{<}N`
  766. Trigger:Text:Init2=AFTER UPDATE POSITION 0 AS`\N`BEGIN`\N`END
  767. Trigger:Text:Get1=CREATE TRIGGER `N` FOR `{<}N`
  768. Trigger:Text:Get2=`=Type` POSITION `=Position` `=Text`
  769. Trigger:Text:RE=CREATE\_+TRIGGER\_+(\w+)\_+FOR\_+(\w+)\_+(\w+\_\w+)\_+POSITION\_+(\w+)\_+(.*)
  770. Trigger:Text:Set=*N=1,2=`{<}N`,Type=3,Position=4,Text=5
  771. Trigger:Delete:Text=DROP TRIGGER `O`
  772.  
  773.  
  774.  
  775.